SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534150 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534150 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391229,418419,668184,383191,775154,132888,739351,726485,70326,688786,843375,408115,385573,167532,246863,772703,163390,1034430,535619,989052,386653,190185,828217,1009684,738231,783387,264883,404049,464220,511628,310071,131,288998,683714,450681,947839,255118,399273,243406,409301,941363,876040,905046,473929,733639,39870,251887,121421,818931,843935,582235,723393,392609,203330,1012293,287366,695273,249557,866016,952351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]