SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901130 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901130 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323448,512424,888688,869613,24718,137605,599394,190393,885734,449907,910263,1023765,337050,864782,877357,408553,758314,951002,5267,225022,546972,20239,557383,1044651,992672,870605,249780,88530,124275,71060,34854,277658,696337,465972,535842,559024,452690,239664,553325,242006,901397,94461,1019148,963380,206436,912834,104264,651558,481581,524590,277681,863377,926891,943859,63307,283776,198609,123920,931567,585011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]