SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522064 LIMIT 1 [ RunTime:0.001312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522064 [ RunTime:0.003093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197115,347821,153498,588357,269652,1016943,507929,339746,431801,635837,491126,420469,593857,354876,359607,815237,320515,105388,982670,223199,293648,136806,427500,773619,478474,703818,796011,379824,436536,910645,775902,338060,79538,473969,817088,1000085,537707,613080,509852,683609,492054,38055,47769,375682,605951,50486,930846,1030153,723349,968530,739860,807650,756282,359953,356403,167571,532930,361643,97441,531057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]