SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410444 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410444 [ RunTime:0.001279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351038,220720,184555,320200,737247,228907,641335,681075,102086,652715,401270,178624,564393,314165,962749,280941,775987,845741,214031,348178,677577,420503,169123,256306,529786,361553,394311,499124,709006,998377,219910,496865,314620,150534,791926,880995,349631,940421,455431,918338,946121,525368,740590,472926,586016,785056,285395,934771,541111,239578,845873,879072,492212,414877,30616,172266,472567,292161,964658,16276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410444 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410444 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]