SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306734 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306734 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823038,718720,320340,345733,631552,789775,615008,602947,790111,736986,453628,140978,429097,507428,849432,808272,892420,924285,767564,101400,481158,135254,892935,514171,592330,242874,803156,951322,392680,372003,448122,813447,160920,659395,351573,9050,468342,382406,1018035,90907,894219,208256,116047,235401,762286,454111,771224,205367,707851,1008424,598948,97640,448401,382318,1039302,748381,740702,841641,990708,61803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306734 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306734 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]