SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34190 LIMIT 1 [ RunTime:0.002469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34190 [ RunTime:0.004430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614914,553453,155981,795254,135639,1002560,1043210,389805,1043117,738983,95762,530090,693319,448694,146167,979180,1045872,741727,1042717,540649,429722,363305,729611,514099,889238,969221,1018570,703525,201435,655724,944595,196052,1047640,693259,219105,759113,1031919,618848,712641,525587,539612,277368,925908,373410,822550,739517,151913,906256,22731,673440,225346,827805,849373,903555,781600,1012344,464452,510356,438226,326172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]