SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489576 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489576 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51297,1021288,89262,610480,488570,770969,484824,1008222,651312,933249,719391,148727,962499,1007233,474983,1031736,887588,963535,638627,32587,264765,908723,234676,598082,760636,972290,485914,590937,873576,1028056,213329,609118,151588,173182,240620,1042738,435468,408935,448052,175593,359358,853232,637580,807889,855229,409531,89822,299069,951698,478553,617299,947153,435901,652516,815747,577964,24344,342913,1015651,408489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]