SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44840 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44840 [ RunTime:0.004819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381934,46939,988181,652072,174499,924260,319727,1045996,659964,698519,565473,231455,362908,787042,983532,995580,988552,1045832,720090,39767,266777,521843,3808,283385,35655,518102,178505,91399,998544,867735,704211,540971,33890,743374,378258,1018968,990888,883636,792232,31383,513679,967637,651355,297897,1034364,757359,519115,508295,639474,536663,876483,897692,14766,1005330,344616,115392,1001895,136512,814078,94524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]