SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328185 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328185 [ RunTime:0.005855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729017,590090,1032477,877193,842280,770601,204087,843692,327607,479599,113405,506915,52684,405444,1020366,419491,169721,679973,847512,773774,134000,780159,66785,761900,958028,238693,238296,901718,150379,348672,750840,802387,630839,452611,126120,425842,731773,15424,284167,204819,337036,897112,147201,653157,32999,75731,123434,736711,140274,961749,833041,90003,764754,499263,83065,129568,784577,707997,157937,280127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]