SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345511 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345511 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191217,969754,17699,741434,706459,322480,389168,686054,388465,110847,483264,99371,926060,513546,937823,603897,87208,845149,496985,122614,881758,551609,777305,917531,824852,859692,596986,421226,103161,755671,227577,51185,211710,942468,231986,52613,292628,215045,447978,109115,886811,82195,82314,1002063,1034909,1029094,34850,44215,250847,460113,401217,803051,207529,663214,879283,789140,218676,224976,816573,760011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]