SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340174 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340174 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802730,1044558,245734,719329,204723,1001561,535842,349023,191417,846127,128553,247088,315004,545667,99886,208731,1017616,297390,331402,674166,1550,728828,13490,940794,463102,156983,952930,1023195,770648,700408,749221,710187,824729,706744,1046977,521286,507590,69840,435470,33738,126918,769917,1032756,793078,891669,207987,544060,305496,824942,952429,446405,818994,514881,209597,1020306,299944,476923,982119,164172,289560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]