SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031923 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031923 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576570,849524,961852,952645,320922,755316,49252,476858,601688,538922,427781,425642,378625,562530,381663,137113,238231,738406,931523,1048011,338788,3774,726219,616624,817906,252935,229329,155385,618046,673050,694890,586456,71356,588646,285684,392845,402212,269119,219615,796610,329408,370114,732270,635007,970296,115627,572166,951110,981547,748487,226705,921307,109733,602644,402180,958054,968140,229439,891450,177804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]