SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042134 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042134 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642725,860320,553620,158198,371183,419340,902442,1032230,490147,21891,281869,707071,954300,919506,851917,324423,108741,758922,782585,953835,496901,390951,143311,566676,288138,644687,787358,1024739,166023,856201,163536,661803,858193,549790,265276,967043,513368,960028,151252,528378,772934,852686,319943,1023330,130078,395908,229498,93236,788885,1024641,622010,384801,944663,422372,942917,424607,992609,399914,764239,73874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]