SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459409 LIMIT 1 [ RunTime:0.003330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459409 [ RunTime:0.004651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137054,910155,46653,297790,788116,61289,579216,124655,578197,663643,835380,835905,30692,286838,516496,179686,794529,814528,359495,73775,441405,399244,661696,50070,645995,1003823,895409,660441,136768,874286,695659,560901,790517,973825,264144,322919,977322,348317,406147,632013,448598,229659,673489,235805,621976,989257,372784,774049,826240,981400,945472,483581,114070,835900,170927,93884,48708,696839,113150,671913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]