SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508062 LIMIT 1 [ RunTime:0.000601s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508062 [ RunTime:0.001321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432192,727074,958856,752560,470130,378536,95019,524473,695332,615391,157015,1014420,547371,354518,912936,866967,406845,109480,647088,185348,640210,1040376,927447,585320,37754,163470,817341,983017,864499,774396,511242,568982,957134,720335,809850,993717,771447,478112,98552,972631,251827,863407,48965,326347,665469,877616,51790,87696,219735,952588,557707,300664,930298,618978,743908,906607,724590,605161,436403,897159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]