SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566806 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566806 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140815,289183,65049,756701,976672,375082,756573,90569,542563,985987,596111,989850,325977,386161,562164,541723,290689,496791,608451,263441,83084,607380,1014499,567326,418465,582952,261365,603047,562644,857661,658754,982941,993262,605040,234323,384452,262813,371274,7014,672038,952973,944923,579616,996349,894128,1048334,767507,604034,805479,769034,501339,994601,824190,656851,43843,449384,272469,445859,704959,617974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]