SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805422 LIMIT 1 [ RunTime:0.000755s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805422 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041636,670636,113831,168854,297191,991230,568443,174787,894676,612242,199367,637162,636153,396356,600640,477393,979058,693716,551310,606790,376106,820644,668869,816503,913241,537533,406503,1270,329709,541234,995322,252289,119566,657148,787067,149523,892492,604524,407003,974726,507695,991501,857489,257310,738050,927004,283986,433885,677322,660670,1032737,769084,651224,932741,255353,882566,451575,463118,791530,432071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]