SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807070 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807070 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6549,51452,119226,575641,494096,31576,224398,647179,487196,640267,324396,684460,31139,34843,569423,334374,286910,287728,222625,601376,704847,125320,491552,333646,71877,668505,198900,153495,763826,144743,772253,874507,574815,568690,1027819,540688,434833,980359,220675,429547,449977,98975,388126,78581,472314,54978,632621,307406,354069,242850,824099,551006,69929,84664,941006,363215,374207,472820,552772,531392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]