SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409014 LIMIT 1 [ RunTime:0.002619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409014 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388317,604006,271880,8649,280530,304625,396701,311941,661657,923329,991177,686119,265565,601334,212974,425658,299644,768203,434953,33642,388122,208198,81350,766459,174093,755247,804439,394252,843640,20097,254671,477793,277336,922163,744130,1034210,215553,50915,817745,866796,873219,504241,824036,68347,302703,654341,29539,145072,409964,461571,482459,415355,979992,73469,459367,391593,710754,879944,893191,987649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000924s ]