SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550940 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550940 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895639,724329,61469,536983,535177,450495,639031,900906,698601,103747,310236,680641,146263,722642,977720,415679,79177,611904,140452,609991,353788,123447,980769,770347,949962,1021672,704023,100810,683415,449956,404561,170107,493588,654703,758226,160353,72026,71490,1047064,985153,852325,1022454,245413,265646,175820,238028,691289,338047,190378,321935,416425,56378,156283,434970,320648,994514,298648,985471,845387,468547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002344s ]