SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813435 LIMIT 1 [ RunTime:0.003729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813435 [ RunTime:0.003129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582721,827211,927845,1008059,602938,451002,460089,356546,123120,985238,982675,198494,233747,995352,326556,63280,663767,174749,367331,460954,298985,402595,340431,125131,106009,17203,114027,398981,13696,871853,1018604,788362,243402,738771,648973,426309,912713,798860,363740,120637,58149,725219,220587,370518,842196,224428,675230,828891,128959,63336,651439,856970,108957,882244,490488,990983,840960,205584,547300,699582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]