SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040828 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040828 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249320,240710,445110,245150,631455,955869,317202,878939,444319,97782,452031,370084,770938,529290,529270,465616,611941,384674,663828,919679,409179,889399,970651,1027897,932317,242269,266050,791559,1013883,470626,752120,59828,288642,743388,182175,508575,173502,5906,771107,781412,819518,542924,91382,53950,737522,280298,341847,55005,494297,993370,386298,895230,64801,360736,94337,299319,543640,161431,1003948,337190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]