SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201919 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201919 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606282,426283,716423,153854,554643,806475,887483,287386,295114,579870,322382,760662,232615,317406,964688,1009089,884601,424874,803282,840988,1036474,545036,937000,60141,254633,995507,37453,291711,542329,608660,39366,451900,598810,533148,283697,635168,150967,543725,743873,556945,752646,368799,98477,462823,1003744,676759,34471,198204,547037,250328,460815,131150,359265,1033263,54380,1008242,468533,21384,660787,139389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]