SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410606 LIMIT 1 [ RunTime:0.001322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410606 [ RunTime:0.003579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836365,431511,41945,233218,223266,1021566,703349,65255,934253,195853,777057,798669,718117,953645,13528,15908,754293,172766,822800,530937,369908,967220,186079,161388,591052,998161,391889,829901,912950,884783,347389,465412,102702,502713,467375,54881,828552,280776,470442,264080,133332,236178,397084,619753,561804,450951,760847,93565,791645,95710,927297,1002199,293800,642433,900427,848554,681223,743623,97772,280937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]