SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105660 LIMIT 1 [ RunTime:0.002544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105660 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145311,476150,485862,717351,736470,148277,1011224,150126,606919,950653,544059,590810,367631,330263,917058,369275,475003,363331,472028,843438,772151,103953,395511,857101,469546,137862,776860,746283,699669,408638,575966,359855,708385,221502,598627,130417,647260,865083,855460,73022,208458,998063,28843,374073,658635,317268,382389,990970,785313,16043,113497,723459,662643,751159,173859,581648,809988,159075,200176,194449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]