SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002933s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422844 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422844 [ RunTime:0.001375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496557,381204,153783,680805,83270,92741,56796,682862,579862,85487,302803,274745,72533,616295,31464,596728,891228,749110,412773,516421,359958,171523,262009,715381,806072,107490,771215,607096,120589,735914,29264,620943,718705,288668,462736,351981,182375,74536,435519,948132,430552,347836,471456,86422,951974,769178,785003,955219,693374,543823,960775,373516,382781,455325,60489,769332,67009,152268,744467,957615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001936s ]