SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344040 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344040 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338133,606929,200351,45715,530144,98512,665855,993290,29825,336111,602645,101686,623394,1028921,315059,323838,578591,557721,644755,289480,371829,975921,524388,119033,146987,271718,618676,218652,131781,340668,186235,395512,433263,611056,390254,787527,998241,687909,739289,638037,606244,843322,193402,212658,894089,153659,876555,539831,449364,97756,563532,895151,15933,411820,952277,509475,19583,531772,250716,447273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]