SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478913 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478913 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337037,807941,659820,588455,925992,818486,237847,768904,466814,993589,350747,505390,79084,483559,649443,522831,576628,517474,5713,75166,130267,282680,115182,538827,613623,137182,674994,184257,952421,190868,355844,935171,580339,382050,754411,335311,573684,103613,172221,1038887,745702,198944,667584,572706,163145,42641,989301,181867,100739,888545,903037,1022924,65747,375082,694366,246897,840190,601092,910771,836202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]