SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553763 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553763 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024022,817884,912041,1036025,645299,690561,661847,17805,414335,117008,306220,223230,809083,563594,505788,963744,955887,492834,918140,802179,799168,536960,679890,998228,353376,746018,4525,8581,963657,765081,208891,318915,364824,827085,354126,443556,239430,281821,23875,415481,226589,43032,533885,954078,1034938,448608,362136,13131,806501,536662,557749,39788,82197,135141,240954,401713,725443,92139,64653,384536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]