SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508140 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508140 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123016,1003282,841328,145710,170256,329296,757826,756561,636184,471442,805050,275929,31066,24363,730722,26993,724480,691945,232211,705018,412971,460835,448650,743303,750193,920476,555974,632892,32905,298199,841249,721735,1000927,849804,135944,936786,865433,79037,324784,31281,127173,1047197,665468,529079,24295,658060,354360,465398,67982,91196,908941,1045449,426573,456624,960593,327119,487607,801941,375507,723871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]