SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415689 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415689 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615759,105802,789834,1041560,448400,812408,425020,43039,767699,827694,1001778,722582,482405,515738,140504,785524,354170,595553,120793,719048,890762,730313,349910,55683,6600,615209,914428,190681,624786,422862,1032934,125255,704983,723159,1047946,125712,643193,93407,522629,711613,37031,846929,487459,705764,25850,321878,373286,1024287,124144,817445,478848,471436,844915,580555,797063,161586,390078,7962,237980,304458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003410s ]