SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350003 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350003 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137587,347421,738781,345521,753553,246434,308168,517255,55967,883187,652781,800201,285313,850161,476821,335510,951807,563632,346219,1003199,929964,638940,142139,362640,905359,23927,650530,212482,1038800,253200,438803,465465,87958,35708,593338,552363,635633,482087,779417,556757,767063,611900,808752,899811,26096,593504,1004902,504385,234187,1017287,104273,199271,28883,834599,33437,944612,451193,371228,786241,157867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]