SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551221 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551221 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206311,492035,1001875,331745,244967,733399,479951,142859,1045039,963897,121563,432208,306747,16665,438888,332922,822295,1021900,1019498,952931,985196,816028,317381,668267,835261,92606,955297,1014281,661413,481015,49624,849482,963198,545725,1009003,688174,889093,115091,440089,393658,625789,984621,308827,818575,864792,593408,410275,662481,142970,29775,646543,860176,249721,959465,717961,150053,876549,147457,473091,210681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]