SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039241 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039241 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993304,244682,434984,48560,909581,665849,642238,842930,73054,998234,556474,309040,209333,186618,157878,1003275,547463,672260,715602,812295,1034840,694526,314954,77844,139629,86897,627126,595845,509215,498117,114143,499232,18495,666923,860390,635559,223242,890529,95723,482752,236964,502124,68155,509197,32672,263030,482929,203581,11551,553378,648059,525206,880000,94047,662800,304390,592556,859274,153325,189168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]