SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436320 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436320 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93443,964406,129414,1005733,662054,180396,560198,727830,471639,35609,530748,499176,591975,794108,43780,286583,724339,688909,681766,14847,116527,930895,451084,225246,304947,450422,557294,252584,150434,58275,508938,314318,272568,704586,170746,773769,176271,1043097,699486,247396,327281,393992,832226,572489,72706,629502,363950,572019,408594,322047,28047,10553,135402,12382,446355,363075,47582,285994,518478,360184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]