SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492413 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492413 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029072,694326,214405,278970,851790,552265,553973,519489,125696,720862,4999,375129,421651,142183,468515,347075,124064,35746,903687,107702,445875,910034,779012,475907,238517,844716,474820,75228,293224,794695,352931,933965,789479,915374,12678,342667,183230,161473,941673,765255,882238,894790,437843,292735,868103,686426,916759,965062,899546,901207,810012,62086,608501,737219,593602,102394,719750,4792,766788,1043097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]