SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267794 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267794 [ RunTime:0.003729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796136,157431,440273,259413,609433,100109,108999,387549,890182,714380,107322,429285,961408,630458,750744,595248,305092,221482,677128,55600,738905,107966,122853,225004,347171,288025,429510,717993,823193,621636,283454,858450,1035189,220404,744502,910072,408036,130100,639939,112612,997065,181532,603685,917528,857561,26964,62444,462308,163244,123084,810716,680900,597299,257753,836205,155115,925237,166096,319283,771538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]