SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410231 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410231 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56385,481712,226330,164655,561325,722541,547658,306692,78049,796512,383466,1004113,286718,450617,444915,96770,585814,648141,478306,912764,684990,237861,770007,755647,790103,636267,98460,659814,423527,284405,452200,233136,318648,81005,661062,631085,727401,722528,864610,48065,890360,877180,676405,162919,482182,691010,556798,196210,939226,629099,280906,110806,19749,715688,114448,628681,305340,534260,506425,761030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002627s ]