SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017888 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017888 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606817,377410,159972,714124,294173,890414,1036867,731548,198891,536592,560878,830469,627579,995634,678877,938422,849269,1013451,767275,1020234,427158,797393,726279,760016,388083,351043,114927,221947,197629,793831,417600,488752,1010106,680461,154884,736058,492492,959972,592200,616199,914638,580093,868242,10005,455880,156728,351803,462795,487770,916417,778348,179813,153992,878350,696435,160299,446701,900771,1031759,844591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]