SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481181 LIMIT 1 [ RunTime:0.001412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481181 [ RunTime:0.007648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367297,271360,197094,964139,146696,256110,458862,655173,464603,353648,537211,171308,193982,504598,685489,40911,715260,553250,838619,189740,960866,1023989,790844,248882,845432,711202,420541,911505,672302,118482,472786,930161,232521,254546,780503,534860,608349,734510,32356,920175,195662,853399,1007055,176302,33964,190815,773968,412872,443576,604081,957955,179244,768398,330576,427688,65230,374358,219532,786477,788445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003043s ]