SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805282 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805282 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649754,595868,914480,471846,953542,415727,107264,338679,245841,615285,612852,995832,382585,330558,793756,1042008,39527,874349,461630,938145,33185,559340,546909,880145,185488,655925,909121,143193,927810,751297,443436,449140,304160,705296,345712,911277,404410,800528,819729,486507,13612,24155,219046,834725,721113,687161,172993,550709,729910,188522,552969,959522,923803,191049,783494,625989,48213,297559,537301,459728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004909s ]