SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145494 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145494 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820058,596688,803050,154855,625568,50632,177433,808758,502714,654544,205195,972268,24175,254340,510606,476569,365194,717340,944832,933872,777473,15925,103459,144552,107777,28518,230873,500517,778133,77970,531249,123367,520878,986540,215550,854735,113844,881640,492090,561095,889690,136675,672763,357391,789191,693,455515,706654,712452,465203,501332,1027293,923417,661372,325031,480220,598058,835471,421174,361429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]