SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002784s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407012 LIMIT 1 [ RunTime:0.001311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407012 [ RunTime:0.005186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045952,354652,572131,530812,825553,592034,282293,991920,70208,5721,9005,716454,302346,147264,879444,383194,718009,181361,119573,377133,234218,793675,200005,771893,997009,896641,542737,845007,683369,889339,767097,916338,856557,38666,1029332,981220,425681,257688,1035404,355818,711481,79952,735211,90148,667444,414929,882613,703266,197923,737225,843480,636152,729175,554227,477118,921516,1045285,60179,514980,483618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004160s ]