SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415495 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415495 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509344,695920,973986,1007864,787695,649393,881855,768874,1008862,109225,909209,989304,870625,956894,995711,904946,307949,220255,340364,41521,193256,235399,218830,403241,276773,986126,329563,14361,16031,145259,193326,816473,275278,434409,666946,705888,1018037,479764,211545,645851,1039251,338253,15385,139356,569279,307559,352047,512449,985995,193123,742308,837655,548353,496517,1032711,343789,705461,431231,404571,1023752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]