SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405215 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405215 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733451,251482,519643,401117,381467,359722,811554,588818,701267,345696,194469,328255,8263,596192,356889,938407,83283,888466,650372,281577,604790,713725,726218,747176,291600,851106,407652,686910,882748,423232,855477,501740,2683,653477,164956,291062,559735,394723,912924,548106,963526,45672,16620,355374,929705,483022,903943,418625,74077,131417,948270,601757,976830,770091,246974,418799,455752,969348,506884,299278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]