SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013342 LIMIT 1 [ RunTime:0.002251s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013342 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447223,35691,890677,312070,929071,347291,690972,841424,433272,426087,699520,760505,612101,555716,803127,1014658,223851,132053,983260,50601,746532,655376,380077,413126,791061,857956,967728,586324,646806,202210,155312,703014,459876,195777,332738,311044,259995,70348,885937,265220,948009,120766,599350,102800,707108,558103,76517,480479,683619,1005878,379337,283175,334166,969966,644081,204671,869601,41593,988239,47705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]