SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398443 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398443 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733743,507300,682610,651616,531354,906666,883126,643648,695581,719989,311097,815891,187285,296806,727034,1008057,868053,966357,556047,1002744,1037225,357913,614538,553594,638483,520495,594931,755654,987859,1011603,695426,1016181,156599,767884,94736,230687,406962,288468,982709,772359,537263,418421,79219,251827,179786,213561,32309,993834,652425,1039988,155355,244292,500509,431292,366478,287792,830679,206621,485501,892536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000365s ]