SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394512 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394512 [ RunTime:0.002881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37275,890094,629803,667440,211381,417093,628194,362572,662842,144121,977376,680902,498171,892287,729056,61759,1002875,371770,66356,491216,310593,62331,910398,235669,708168,358512,265729,641184,387931,470123,1047271,292669,140857,689025,66984,517200,580874,159285,381441,342837,835990,432434,1022893,739427,72002,855343,150553,1026074,246749,296625,618429,958154,725762,903768,907082,561091,250223,589724,931167,790032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001623s ]