SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017173 LIMIT 1 [ RunTime:0.000751s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017173 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520118,350785,83987,981123,677195,992826,497278,510134,417702,732756,526603,428819,995224,157482,927020,545922,848329,702170,738480,499371,36902,1035928,443489,1026950,227507,524910,787282,108129,514951,247801,742783,286931,244516,298199,550384,488867,717226,261277,146111,401524,676167,138280,288952,482509,410514,491273,554927,686783,953581,472988,285037,303652,491831,908982,536145,407,141531,273334,975527,574995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001048s ]