SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016114 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016114 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535492,467852,1021927,30957,658177,282586,492871,302291,287886,574227,212001,105392,286353,640603,299159,927312,1033247,655708,729638,536354,747120,148203,1044568,102712,325749,761404,258342,152853,438844,678138,29083,423928,629207,720298,72348,98975,1031124,431828,73420,115234,248995,484478,422721,653818,498959,700824,1027510,499543,483070,204794,530843,945989,678040,973876,140573,855665,897512,202443,323223,857676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]