SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543600 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543600 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898512,765652,26804,428280,312254,500542,874716,817432,1041341,743739,112109,705089,181412,388266,1048552,943439,514488,700815,817384,32336,1025765,255337,891487,858004,44138,284769,653879,471819,573071,328362,292950,285252,172525,755074,986456,572989,77062,22099,852792,535999,124170,198120,147902,935672,353273,99852,596229,278603,198864,787554,980884,536705,344600,283455,789886,660284,970567,136443,155813,279730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]