SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424046 LIMIT 1 [ RunTime:0.000719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424046 [ RunTime:0.002469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902295,506690,369322,143764,774637,274837,254770,1017587,1024369,334852,414302,406229,359217,680385,739143,545146,496700,459488,521964,706951,655824,551425,711010,715768,61357,482762,589904,902579,414252,541581,803216,606620,253525,724034,687210,759004,836898,995687,36834,164921,224211,696749,319739,238048,515640,861753,924376,551330,121252,473540,570728,495289,763941,59520,284889,491094,652778,313886,528244,306794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001054s ]