SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392611 LIMIT 1 [ RunTime:0.002039s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392611 [ RunTime:0.004255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543155,646740,543787,296991,463229,549758,740042,605112,724281,891641,303230,78379,741239,245588,317530,998390,606674,555441,1039674,863609,465008,957018,670776,596244,416134,173251,457108,911747,897560,758840,735059,1005043,386387,192177,114677,177284,13849,189385,278824,82165,868478,393012,295899,460729,865918,815964,396082,325993,604975,584562,165767,838344,776171,1004438,1028300,36286,895187,157753,576259,870099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000370s ]