SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386216 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386216 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177708,200135,514508,462100,1045734,264368,197048,337950,717926,977705,269598,25060,806422,170920,144053,977179,666919,98201,131783,912335,196555,193485,268842,709185,966920,827160,323594,708357,1046386,1001524,919369,68345,707833,215602,24854,331560,670943,519536,822222,288112,902822,116448,1042678,960011,12059,11469,875289,935176,398159,318178,331992,799885,847,116877,266541,826640,78853,803581,896194,813609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]