SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245214 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245214 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218067,828996,944255,797072,285341,651691,648773,637032,526115,278071,763546,366338,245139,1025680,498643,546082,236279,838449,100508,68484,709812,457480,218321,869646,787060,867090,565315,365169,700880,732053,369573,231155,1007340,544453,930105,305658,1032355,481077,173804,707058,123339,322188,205606,316215,304074,204849,310877,343170,774452,26914,672048,98558,718729,116296,50921,1047908,484083,129092,680685,956239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]