SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501272 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501272 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6011,407319,1030984,246287,161538,263006,153590,650771,920232,279823,92668,987082,239809,483610,813906,851361,497348,113525,187304,960491,553089,369587,1009341,699363,552406,261455,318437,998125,827253,908179,450950,717511,276277,209932,735272,982666,83899,744005,846131,968245,140110,685488,481172,221211,871469,797956,440206,868239,247238,74923,845468,723249,381936,680258,535486,375239,609515,1029987,478043,356770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]