SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40620 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40620 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125376,355641,994730,791854,325924,412010,18331,1041001,362634,739781,310515,487136,153693,305186,538714,791635,894415,311754,845646,219925,900966,175880,195511,599527,768961,318530,200783,734544,482570,835879,528569,172638,396207,681707,728789,188114,512251,387349,556373,768432,916780,877807,672346,331018,14728,409910,95740,710291,690120,1029437,1037909,446054,742067,990923,519072,989038,914633,929193,7423,800317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]