SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504773 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504773 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351258,325560,254637,1031361,33476,310481,78004,158709,701825,985587,950045,1034008,419355,414341,788541,516212,796065,769170,467497,526935,356571,293673,1047618,203197,213596,961845,603561,144223,152813,357532,893238,591122,226737,336579,683531,448032,582107,8703,83212,716123,11946,512556,222100,305154,851309,630234,999650,421250,967187,960912,831408,1024172,800106,659147,309845,239984,359190,32946,77954,710328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]