Danh sách tìm kiếm bài viết ""gbase"-"数据"-"database"-数据安全与智能应用171. 如果从头设计一个数据库，你会做哪些不同选择？"

Tìm kiếm bài viết

Tin tức mới

Array
(
    [query_count] => 32
    [query_time] => 0.25611
    [list] => Array
        (
            [0] => Array
                (
                    [query] => 
										SELECT 
											id
											, `name`
											, parentId
											, imgUrl
											, img_big
											, isParent
											, request_path
											, is_featured
											, summary
										FROM idv_seller_category
										WHERE 1  AND `status` = 1  AND `status` = 1 
										ORDER BY `ordering` DESC
                                        LIMIT 5000
                           		 
                    [start_time] => 1781660203.9079
                    [total_time] => 0.00367
                )

[1] => Array
                (
                    [query] => 
                                    SELECT id, `name`, summary, parentId, isParent, imgUrl, `type`, request_path, `item_count`
                                    FROM idv_seller_news_category
                                    WHERE 1  AND `status` = 1 
                                    ORDER BY ordering DESC
                           		 
                    [start_time] => 1781660203.9179
                    [total_time] => 0.00033
                )

[2] => Array
                (
                    [query] => 
                                    SELECT 
                                        id
                                        , `api_key`
                                        , `title`
                                        , `summary`
                                        , `title_en`
                                        , `summary_en`
                                        , parent_id
                                        , summary
                                        , thumbnail
                                        , is_parent
                                        , url
                                    FROM `menu`
                                    WHERE 1  AND `status` = '1' 
                                    ORDER BY ordering DESC
                                    LIMIT 5000
                             
                    [start_time] => 1781660203.9237
                    [total_time] => 0.00023
                )

[3] => Array
                (
                    [query] => (
                SELECT  a.id , a.location , a.location_index , a.name , a.summary , a.category_list , a.fileUrl , a.desUrl , a.type , a.width , a.height , a.template_page 
                FROM `idv_seller_ad` a
                WHERE a.template_page='footer' AND a.status=1
                     AND (a.to_time = 0 OR ( a.from_time < 1781660203 AND a.to_time > 1781660203 ) )
                     
                ORDER BY a.ordering DESC
                LIMIT 200
         ) UNION ALL (
                SELECT  a.id , a.location , a.location_index , a.name , a.summary , a.category_list , a.fileUrl , a.desUrl , a.type , a.width , a.height , a.template_page 
                FROM `idv_seller_ad` a
                WHERE a.template_page='header' AND a.status=1
                     AND (a.to_time = 0 OR ( a.from_time < 1781660203 AND a.to_time > 1781660203 ) )
                     
                ORDER BY a.ordering DESC
                LIMIT 200
         )
                    [start_time] => 1781660203.9382
                    [total_time] => 0.00033
                )

[4] => Array
                (
                    [query] => 
								SELECT  id FROM idv_seller_news
								WHERE 1  AND `type`='article' AND `status` =1  AND `article_display_time` <= '1781660203'  
								ORDER BY ordering DESC, id DESC
								limit 10
                    [start_time] => 1781660203.9523
                    [total_time] => 0.01002
                )

[5] => Array
                (
                    [query] => 
							SELECT
								id
								, article_category
                                , title
                                , extend
                                , thumnail
                                , summary
                                , createDate
                                , createBy
                                , lastUpdate
                                , lastUpdateBy
                                , `ordering`
                                , visit
                                , is_featured
                                , lastUpdateByUser
                                , article_time
                                , request_path
                                , review_rate
                                , review_count
                                , video_code
                                , comment_rate
                                , comment_count
							FROM idv_seller_news
							WHERE `id` IN (1332,2565,2564,2561,2559,2558,2550,2549,2601,2600)  AND `status`= 1  AND `article_display_time` <= '1781660203' 
							LIMIT 500
						
                    [start_time] => 1781660203.9626
                    [total_time] => 0.00141
                )

[6] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (45) 
                    [start_time] => 1781660203.9643
                    [total_time] => 0.00028
                )

[7] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28) 
                    [start_time] => 1781660203.9647
                    [total_time] => 0.00025
                )

[8] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28) 
                    [start_time] => 1781660203.965
                    [total_time] => 0.00026
                )

[9] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28) 
                    [start_time] => 1781660203.9654
                    [total_time] => 0.00038
                )

[10] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28) 
                    [start_time] => 1781660203.9658
                    [total_time] => 0.00029
                )

[11] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28) 
                    [start_time] => 1781660203.9662
                    [total_time] => 0.00022
                )

[12] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28) 
                    [start_time] => 1781660203.9664
                    [total_time] => 0.00025
                )

[13] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28,28) 
                    [start_time] => 1781660203.9667
                    [total_time] => 0.00025
                )

[14] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (58) 
                    [start_time] => 1781660203.9671
                    [total_time] => 0.00026
                )

[15] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (58) 
                    [start_time] => 1781660203.9674
                    [total_time] => 0.00025
                )

[16] => Array
                (
                    [query] => 
								SELECT id FROM idv_seller_news
								WHERE `type` = 'article' AND `is_featured` = 1 AND `status` = 1 AND id != '0'
								ORDER BY ordering DESC, id DESC
								limit 20
                    [start_time] => 1781660203.9691
                    [total_time] => 0.00022
                )

[17] => Array
                (
                    [query] => 
							SELECT
								id
								, article_category
                                , title
                                , extend
                                , thumnail
                                , summary
                                , createDate
                                , createBy
                                , lastUpdate
                                , lastUpdateBy
                                , `ordering`
                                , visit
                                , is_featured
                                , lastUpdateByUser
                                , article_time
                                , request_path
                                , review_rate
                                , review_count
                                , video_code
                                , comment_rate
                                , comment_count
							FROM idv_seller_news
							WHERE `id` IN (975,2614,2000,1779,1760,1718,1689,1447)  AND `status`= 1  AND `article_display_time` <= '1781660203' 
							LIMIT 500
						
                    [start_time] => 1781660203.9694
                    [total_time] => 0.00135
                )

[18] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (4,34) 
                    [start_time] => 1781660203.9708
                    [total_time] => 0.00031
                )

[19] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (40) 
                    [start_time] => 1781660203.9712
                    [total_time] => 0.00025
                )

[20] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (39) 
                    [start_time] => 1781660203.9716
                    [total_time] => 0.00024
                )

[21] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (39,39) 
                    [start_time] => 1781660203.9718
                    [total_time] => 0.00023
                )

[22] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (28,38) 
                    [start_time] => 1781660203.9721
                    [total_time] => 0.00025
                )

[23] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (23,19) 
                    [start_time] => 1781660203.9724
                    [total_time] => 0.00029
                )

[24] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (41) 
                    [start_time] => 1781660203.9728
                    [total_time] => 0.00023
                )

[25] => Array
                (
                    [query] => SELECT * FROM idv_seller_news_category WHERE id IN (4,34,58) 
                    [start_time] => 1781660203.9731
                    [total_time] => 0.0003
                )

[26] => Array
                (
                    [query] => SELECT news_id FROM idv_seller_news_fulltext 
								  WHERE MATCH(news_title, news_summary) 
									 		AGAINST('+quot +gbase +quot +quot +quot +quot +database +quot +hura171' IN BOOLEAN MODE) 
								  ORDER BY news_id DESC 			
								   LIMIT 1000
								
                    [start_time] => 1781660203.9866
                    [total_time] => 0.22833
                )

[27] => Array
                (
                    [query] => SELECT
                                         `COLUMN_NAME` ,
                                          COLUMN_DEFAULT,
                                          ORDINAL_POSITION,
                                          COLUMN_DEFAULT,
                                          DATA_TYPE,
                                          CHARACTER_MAXIMUM_LENGTH,
                                          COLUMN_TYPE,
                                          COLUMN_KEY,
                                          EXTRA
                                    FROM INFORMATION_SCHEMA.COLUMNS
                                    WHERE `table_name` = ? 
                    [start_time] => 1781660204.2151
                    [total_time] => 0.00242
                )

[28] => Array
                (
                    [query] => SELECT COUNT(*) FROM idv_seller_news WHERE 1  AND `status`= 1  AND `article_display_time` <= 1781660203  AND `id` IN (-1) 
                    [start_time] => 1781660204.2179
                    [total_time] => 0.00045
                )

[29] => Array
                (
                    [query] => SELECT news_id FROM idv_seller_news_fulltext 
								  WHERE MATCH(news_title, news_summary) 
									 		AGAINST('+quot +gbase +quot +quot +quot +quot +database +quot +hura171' IN BOOLEAN MODE) 
								  ORDER BY news_id DESC 			
								   LIMIT 1000
								
                    [start_time] => 1781660204.2188
                    [total_time] => 0.00016
                )

[30] => Array
                (
                    [query] => SELECT
                                         `COLUMN_NAME` ,
                                          COLUMN_DEFAULT,
                                          ORDINAL_POSITION,
                                          COLUMN_DEFAULT,
                                          DATA_TYPE,
                                          CHARACTER_MAXIMUM_LENGTH,
                                          COLUMN_TYPE,
                                          COLUMN_KEY,
                                          EXTRA
                                    FROM INFORMATION_SCHEMA.COLUMNS
                                    WHERE `table_name` = ? 
                    [start_time] => 1781660204.219
                    [total_time] => 0.00195
                )

[31] => Array
                (
                    [query] => 
							SELECT
								id
                                , title
                                , article_category
                                , extend
                                , thumnail
                                , summary
                                , createDate
                                , createBy
                                , lastUpdate
                                , lastUpdateBy
                                , `ordering`
                                , visit
                                , is_featured
                                , lastUpdateByUser
                                , article_time
                                , request_path
                                , `url` AS `url_index`
                                , review_rate
                                , review_count
                                , video_code
                                , external_url
							FROM idv_seller_news
							WHERE 1  AND `status`= 1  AND `article_display_time` <= 1781660203  AND `id` IN (-1) 
							ORDER BY  ordering DESC, id DESC 
							LIMIT 0, 15 
                    [start_time] => 1781660204.2212
                    [total_time] => 0.00045
                )

)

)