SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414158 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414158 [ RunTime:0.003226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633217,579552,289564,230978,868282,636774,49695,405005,554336,570796,978062,271666,352513,556032,288234,130139,286457,675897,790928,632435,1034169,384379,41326,943955,555468,424304,511173,595483,424529,554415,54592,407938,16516,348334,872794,977317,503765,477206,38033,520648,153515,530837,199590,1001946,28255,577139,712294,775258,259126,669607,57464,742722,640465,238653,328941,598716,889174,144919,113812,733848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]