SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38023 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38023 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501588,137118,301937,50838,842877,509056,584561,648172,921764,797856,485046,402453,474493,385689,271083,972787,425311,314824,692691,736719,1039261,1038072,780652,735144,436562,607971,968581,397657,762326,351712,503976,168844,543516,996628,496345,883056,427106,751756,316985,752883,353013,955590,217167,919822,513908,894346,169963,579337,666394,355463,216116,218877,787441,527099,90410,861037,343422,494617,252808,501363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]