SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040378 LIMIT 1 [ RunTime:0.000865s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040378 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772221,50309,897131,894809,269256,910859,744987,230526,288046,368090,85673,602505,1035256,238065,746675,6486,341265,688753,399542,36382,1036365,486415,116306,837935,400852,227231,146605,433104,883639,540852,1027167,448819,525149,128976,368497,604843,141927,797941,318862,727740,784773,559920,37489,987448,212032,228469,288153,376932,183328,784133,155573,303339,990813,402971,408308,949569,68851,301300,269824,344782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001884s ]