SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418823 LIMIT 1 [ RunTime:0.001824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418823 [ RunTime:0.007749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492852,758851,135792,228458,668434,23570,770358,251802,787811,522828,992870,532132,384087,390185,623056,474397,740131,1036720,117951,372901,590601,334433,920611,151055,383083,551426,397160,936534,739191,578795,751367,17105,279097,535841,228041,175869,537795,126826,249797,350026,289135,991338,537943,79656,768001,1029247,981924,434037,560656,461816,1040331,1024366,118638,707976,837994,276148,878648,768830,551800,572048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]