SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383141 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383141 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209467,569728,239960,262340,928558,779182,342222,796346,99866,939760,942686,501565,124493,728419,7298,353420,786278,135725,834596,716277,180652,466946,385546,728092,1039754,567934,438100,886139,545922,279539,459395,591339,1025301,1047129,860853,563356,20545,490930,172632,832510,1010106,493530,198902,383831,821530,846036,226587,975654,114550,400630,627416,655635,89311,586953,880649,532660,844316,96455,390594,1004738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]